Fritz: All Fritz/All Fritz.zip/All Fritz/FILES/SPREEETS/TC511.LZH/TC511-EX.SSF

Text File | 1986-01-20 | 7KB | 791 lines

HDR
10
10
10
10
10
10
10
DAT
1,1,2R
Copyright (c) 1985, 1986: P & M Software Co.
7,1,0A
(DATE(85,12,20))
1,2,2R

1,3,2R
This is a sample worksheet, it is what some call a template.  It is setup
1,4,2R
to show you how you can use "Turbo Calc" to do a family budget.
2,5,0C

3,5,0C

1,6,2R
To use the template you just put numbers in for each expense catagory and
1,7,2R
put in the amount for the income figure at the bottom.  The worksheet will
1,8,2R
calculate the total expenses and the amount that you can save or must take
1,9,2R
from savings.
3,9,0C

1,10,2R

2,10,0C

3,10,0C

1,11,2R
"Turbo Calc" can forward reference cells and come up with the correct
1,12,2R
answer, even if the forward cell comtains a formula!  An example of this
1,13,2R
is shown after the "Budget" below.
1,14,2R

2,14,0C

3,14,0C

1,15,2R
At the end of this worksheet is a sample of the technique used for the
1,16,2R
Internal Rate of Return function.  While this function is very nice, it
1,17,2R
does take time to calculate.
2,18,0C

3,18,0C

1,19,2R
Budget
2,19,0C

3,19,0C

1,20,2R
Category
2,20,0E
(DATE(86,2,15))
3,20,0E
(B20+30.4)
4,20,0E
(C20+30.4)
5,20,0E
(D20+30.4)
6,20,0E
(E20+30.4)
7,20,0E
(F20+30.4)
1,21,2R
----------
2,21,0C
----------
3,21,0C
----------
4,21,0C
----------
5,21,0C
----------
6,21,0C
----------
7,21,0C
----------
1,22,2R
Food
2,22,0D
0
3,22,0D
0
4,22,0D
0
5,22,0D
0
6,22,0D
0
7,22,0D
0
1,23,2R
Clothing
2,23,0C

3,23,0C

4,23,0C

5,23,0C

6,23,0C

7,23,0C

1,24,2R
Newspaper
2,24,0C

3,24,0C

4,24,0C

5,24,0C

6,24,0C

7,24,0C

1,25,2R
Insurance
2,25,0C

3,25,0C

4,25,0C

5,25,0C

6,25,0C

7,25,0C

1,26,2R
Church
2,26,0C

3,26,0C

4,26,0C

5,26,0C

6,26,0C

7,26,0C

1,27,2R
Mortgage
2,27,0C

3,27,0C

4,27,0C

5,27,0C

6,27,0C

7,27,0C

1,28,2R
Magazines
2,28,0C

3,28,0C

4,28,0C

5,28,0C

6,28,0C

7,28,0C

1,29,2R
Medical
2,29,0C

3,29,0C

4,29,0C

5,29,0C

6,29,0C

7,29,0C

1,30,2R
Computer
2,30,0C

3,30,0C

4,30,0C

5,30,0C

6,30,0C

7,30,0C

1,31,2R
Auto
2,31,0C

3,31,0C

4,31,0C

5,31,0C

6,31,0C

7,31,0C

1,32,2R
Gasoline
2,32,0C

3,32,0C

4,32,0C

5,32,0C

6,32,0C

7,32,0C

1,33,2R
Electric
2,33,0C

3,33,0C

4,33,0C

5,33,0C

6,33,0C

7,33,0C

1,34,2R
Water
2,34,0C

3,34,0C

4,34,0C

5,34,0C

6,34,0C

7,34,0C

1,35,2R
Loan Pay
2,35,0C

3,35,0C

4,35,0C

5,35,0C

6,35,0C

7,35,0C

1,36,2R
School
2,36,0C

3,36,0C

4,36,0C

5,36,0C

6,36,0C

7,36,0C

1,37,2R
Entertain
2,37,0C

3,37,0C

4,37,0C

5,37,0C

6,37,0C

7,37,0C

1,38,2R
Misc.
2,38,0C

3,38,0C

4,38,0C

5,38,0C

6,38,0C

7,38,0C

2,39,0C
----------
3,39,0C
----------
4,39,0C
----------
5,39,0C
----------
6,39,0C
----------
7,39,0C
----------
1,40,2R
Expenses
2,40,0D
(B22:B39)
3,40,0D
(C22:C39)
4,40,0D
(D22:D39)
5,40,0D
(E22:E39)
6,40,0D
(F22:F39)
7,40,0D
(G22:G39)
1,41,2R
Savings
2,41,0C
(B43-B40)
3,41,0C
(C43-C40)
4,41,0C
(D43-D40)
5,41,0C
(E43-E40)
6,41,0C
(F43-F40)
7,41,0C
(G43-G40)
2,42,0C
----------
3,42,0C
----------
4,42,0C
----------
5,42,0C
----------
6,42,0C
----------
7,42,0C
----------
1,43,2R
Income
2,43,0D
0
3,43,0D
0
4,43,0D
0
5,43,0D
0
6,43,0D
0
7,43,0D
0
2,44,0C
==========
3,44,0C
==========
4,44,0C
==========
5,44,0C
==========
6,44,0C
==========
7,44,0C
==========
2,45,0C

3,45,0C

4,45,0C

5,45,0C

6,45,0C

7,45,0C

1,46,2R

2,46,0C

3,46,0C

4,46,0C

5,46,0C

6,46,0C

7,46,0C

1,47,2R
Sample of the forward reference:
4,47,0C
(G49)
5,47,0C

6,47,0C

7,47,0C

2,48,0C

3,48,0C

4,48,0C

5,48,0C

6,48,0C

7,48,0C

1,49,0C
100
2,49,0C
200
3,49,0C
300
4,49,0C
400
5,49,0C
500
6,49,0C
600
7,49,0C
(A49:F49)
2,50,0C

3,50,0C

4,50,0C

5,50,0C

6,50,0C

7,50,0C

1,51,2R

2,51,0C

3,51,0C

4,51,0C

5,51,0C

6,51,0C

7,51,0C

1,52,2R
Sample problem, showing the use of the Internal Rate of Return function.
2,53,0C

3,53,0C

4,53,0C

5,53,0C

6,53,0C

7,53,0C

1,54,2R
Loan Analysis
3,54,0C

4,54,0C

5,54,0C

6,54,0C

7,54,0C

1,55,2R
-------------
3,55,0C

4,55,0C

5,55,0C

6,55,0C

7,55,0C

1,56,2R
Loan Amount
3,56,0D
-1000
4,56,0C
  Shown as negative, because YOU are
1,57,2R
Year 1 Payment
3,57,0C
500
4,57,0C
  making the loan!  The loan payments
1,58,2R
Year 2 Payment
3,58,0C
400
4,58,0C
  are income to you and you are trying
1,59,2R
Year 3 Payment
3,59,0C
200
4,59,0C
  to decide if you want to make the loan
1,60,2R
Year 4 Payment
3,60,0C
100
4,60,0C
  or not.
5,60,0C

6,60,0C

7,60,0C

1,61,2R

2,61,0C

3,61,0C
----------
4,61,0C

5,61,0C

6,61,0C

7,61,0C

1,62,2R
Net Income
2,62,0C

3,62,0D
(C56:C60)
4,62,0C

5,62,0C

6,62,0C

7,62,0C

2,63,0C

3,63,0C
==========
4,63,0C

5,63,0C

6,63,0C

7,63,0C

2,64,0C

3,64,0C

4,64,0C

5,64,0C

6,64,0C

7,64,0C

1,65,2R
Rate of Return
3,65,4P
(IRR(.14,C56..C60))
4,65,0C

5,65,0C

6,65,0C

7,65,0C

2,66,0C

3,66,0C

4,66,0C

5,66,0C

6,66,0C

7,66,0C

1,67,2R
Proof is NPV of
3,67,0C

4,67,0C

5,67,0C

6,67,0C

7,67,0C

1,68,2R
cash flows...
3,68,4D
(ABS(NPV(C65,C57..C60)+C56))
4,68,0C
  By definition the Internal Rate of
2,69,0C

3,69,0C

4,69,0C
  Return is the interest rate that will
2,70,0C

3,70,0C

4,70,0C
  discount the cash flow to zero!
2,71,0C

3,71,0C

4,71,0C

5,71,0C

6,71,0C

7,71,0C

1,72,2R
 Sample Table Lookup
3,72,2R

1,73,2R
---------------------
3,73,2R

1,75,2R
     Term
2,75,2R
     Rate
1,76,2R
     ----
2,76,2R
     ----
1,77,0C
12
2,77,2P
0.085
1,78,0C
18
2,78,2P
0.093
1,79,0C
24
2,79,2P
0.097
1,80,0C
36
2,80,2P
0.102
1,81,0C
48
2,81,2P
0.107
4,81,2R
 Value "LOOKED UP" in Table
1,82,0C
60
2,82,2P
0.111
4,82,2R
-----------------------------
1,83,0C
72
2,83,2P
0.115
4,83,2P
(VLOOKUP(36,A77..A83,1))
5,83,2R
Rate for 36 months
1,85,2R

1,86,2R
  Sample Asset Depreciation
4,86,2R
  Depreciation Calculations
1,87,2R
-------------------------------
4,87,2R
-------------------------------
1,88,2R
Cost
2,88,0C

3,88,0D
10000
4,88,2R
Double Declining Bal.
6,88,0D
(DDB(C88,C89,C90,C91))
1,89,2R
Salvage
2,89,0C

3,89,0D
1200
4,89,2R
Straight Line
6,89,0D
(SLN(C88,C89,C90))
1,90,2R
Life
2,90,0C

3,90,0C
8
4,90,2R
Sum Of Years Digits
6,90,0D
(SYD(C88,C89,C90,C91))
1,91,2R
Current Period
3,91,0C
5
1,92,2R

END